[dbo].[AddressCategoryPreferences]

Property	Value
Row Count	0
Created	10:31:13 AM Tuesday, March 02, 2010
Last Modified	11:39:59 AM Monday, February 20, 2012

Property

Value

Row Count

Created

10:31:13 AM Tuesday, March 02, 2010

Last Modified

11:39:59 AM Monday, February 20, 2012

	Name	Data Type	Max Length (Bytes)
$Cluster Primary Key PK_AddressCategoryPreferences: ContactKey\AddressCategoryCode$	ContactKey	uniqueidentifier	16
$Cluster Primary Key PK_AddressCategoryPreferences: ContactKey\AddressCategoryCode$	AddressCategoryCode	int	4
	NoSolicitationFlag	bit	1
	OptOutFlag	bit	1
	MarkedForDeleteOn	datetime	8

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Cluster Primary Key PK_AddressCategoryPreferences: ContactKey\AddressCategoryCode$

ContactKey

uniqueidentifier

$Cluster Primary Key PK_AddressCategoryPreferences: ContactKey\AddressCategoryCode$

AddressCategoryCode

int

NoSolicitationFlag

bit

OptOutFlag

bit

MarkedForDeleteOn

datetime

	Name	Columns	Unique
$Cluster Primary Key PK_AddressCategoryPreferences: ContactKey\AddressCategoryCode$	PK_AddressCategoryPreferences	ContactKey, AddressCategoryCode

Name

Columns

Unique

$Cluster Primary Key PK_AddressCategoryPreferences: ContactKey\AddressCategoryCode$

PK_AddressCategoryPreferences

ContactKey, AddressCategoryCode

Name	Columns
FK_AddressCategoryPreferences_AddressCategoryRef	AddressCategoryCode->[dbo].[AddressCategoryRef].[AddressCategoryCode]
FK_AddressCategoryPreferences_ContactMain	ContactKey->[dbo].[ContactMain].[ContactKey]

Name

Columns

FK_AddressCategoryPreferences_AddressCategoryRef

AddressCategoryCode->[dbo].[AddressCategoryRef].[AddressCategoryCode]

FK_AddressCategoryPreferences_ContactMain

ContactKey->[dbo].[ContactMain].[ContactKey]

SQL Script

CREATE TABLE [dbo].[AddressCategoryPreferences]
(
[ContactKey] [uniqueidentifier] NOT NULL,
[AddressCategoryCode] [int] NOT NULL,
[NoSolicitationFlag] [bit] NOT NULL,
[OptOutFlag] [bit] NOT NULL,
[MarkedForDeleteOn] [datetime] NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[AddressCategoryPreferences] ADD CONSTRAINT [PK_AddressCategoryPreferences] PRIMARY KEY CLUSTERED ([ContactKey], [AddressCategoryCode]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[AddressCategoryPreferences] ADD CONSTRAINT [FK_AddressCategoryPreferences_AddressCategoryRef] FOREIGN KEY ([AddressCategoryCode]) REFERENCES [dbo].[AddressCategoryRef] ([AddressCategoryCode])
GO
ALTER TABLE [dbo].[AddressCategoryPreferences] ADD CONSTRAINT [FK_AddressCategoryPreferences_ContactMain] FOREIGN KEY ([ContactKey]) REFERENCES [dbo].[ContactMain] ([ContactKey])
GO